CREATE TABLE [dbo].[RuleFilter]
(
[RuleFilterKey] [uniqueidentifier] NOT NULL,
[RuleCriterionKey] [uniqueidentifier] NULL,
[PropertyName] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ComparisonCode] [int] NULL,
[ValueOne] [nvarchar] (200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ValueOneTypeName] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ValueTwo] [nvarchar] (200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ValueTwoTypeName] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UpdatedOn] [datetime] NOT NULL,
[UpdatedByUserKey] [uniqueidentifier] NOT NULL,
[MarkedForDeleteOn] [datetime] NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[RuleFilter] ADD CONSTRAINT [PK_RuleFilter] PRIMARY KEY CLUSTERED ([RuleFilterKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_RuleFilter_ComparisonCode] ON [dbo].[RuleFilter] ([ComparisonCode]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_RuleFilter_RuleCriterionKey] ON [dbo].[RuleFilter] ([RuleCriterionKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_RuleFilter_UpdatedByUserKey] ON [dbo].[RuleFilter] ([UpdatedByUserKey]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[RuleFilter] ADD CONSTRAINT [FK_RuleFilter_ComparisonRef] FOREIGN KEY ([ComparisonCode]) REFERENCES [dbo].[ComparisonRef] ([ComparisonCode])
GO
ALTER TABLE [dbo].[RuleFilter] ADD CONSTRAINT [FK_RuleFilter_RuleCriterion] FOREIGN KEY ([RuleCriterionKey]) REFERENCES [dbo].[RuleCriterion] ([RuleCriterionKey])
GO
ALTER TABLE [dbo].[RuleFilter] ADD CONSTRAINT [FK_RuleFilter_UserMain_UpdatedBy] FOREIGN KEY ([UpdatedByUserKey]) REFERENCES [dbo].[UserMain] ([UserKey])
GO